/* 
 * File:   DBAccess.h
 * Author  Wang 
 *
 * Created on April 10, 2013, 3:51 PM
 */

#include <sys/time.h>
#include <stdio.h>
#include <mysql.h>
#include <string>
#include<vector>
#define SERVER "mysql.wpi.edu"
#define USER "xguo11"
#define PASS "H7zv39"
#define DATABASE "ticketsystem"
using namespace std;
#ifndef DBACCESS_H
#define	DBACCESS_H

class DBAccess {
public:
    DBAccess();
    DBAccess(const DBAccess& orig);
    virtual ~DBAccess();
    string query_Database(string cmd, const vector<string> &parameter);
    string register_Database(const vector<string> &parameter);
    string login_Database(const vector<string> &parameter);
    string list_Database(const vector<string> &parameter);
    string book_Database(const vector<string> &parameter);
    string view_Database(const vector<string> &parameter);

private:
    MYSQL *connect;
};

#endif	/* DBACCESS_H */

